Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
EventID (FK)(PK) | A unique, automatically assigned identifier for the Event | ID_EV | Identity | integer | |
OperatorID (FK) | A unique, automatically assigned number used to identify a workstation OPERATOR. | ID_OPR | Identity | integer | Operator(PA_OPR) |
CompetitorID (FK) | The unique identifier assigned to a competitor by the store. | ID_CMP | Identity | integer | Competitor(PA_CMP) |
ReasonCode | Establishes a reason for the maintenance event. Reason codes will be determined by each retailer. | RC_EV_MNT | Code4 | char(4) | |
TypeCode | Categorizes the maintenance event based on its intended purpose and subject. Examples include ITEM maintenance, selling rules maintenance, tender authorization maintenance and a whole host of different aspects of the retail store data model that may be maintained from the home office. | TY_EV_MNT | Code2 | char(2) | |
AppliedTimestamp | The date and time the maintenance event's associated adds, changes and deletes are applied to the store database. | TS_EV_MNT_APLY | AuditDateTime | datetime | |
CreateDateTimestamp | The date and time this maintenance event was created. | TS_EV_MNT_CRT | AuditDateTime | datetime | |
OriginTypeCode | The origin for this maintenance event. Examples of origins include: home office, store, etc. | TY_EV_MNT_ORG | Code4 | char(4) | |